CampusGroup 
EntityType  Independent 
Logical Entity Name  CampusGroup 
Default Table Name  SyCampusGrp 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

CampusGroup Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
CampusGroupId(PK)    INTEGER  NO 
 
Code    CHAR(16)  NO 
 
Name    VARCHAR(35)  NO 
 
LastModifiedUserId    INTEGER  NO 
 
IsSystemCode    BIT  NO 
 
SaStmtComments    VARCHAR(1000)  YES 
 
SaStmtLastCloseDate    DATETIME  YES 
 
ModFlag    CHAR(1)  NO 
 
Type    CHAR(1)  NO 
 
IsActive    BIT  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
FinancialCampusGroup    BIT  NO 
 

CampusGroup Keys 
Key Name  Key Type  Keys 
SyCampusGrp_Type_SyCampusGRPID_U_N_IDX  Alternate Key  Type, CampusGroupId 
SyCampusGrp_Type_Code_N_N_IDX  Inversion Entry  Type, Code 
SyCampusGrp_Code_N_N_IDX  Inversion Entry  Code 
SyCampusGrp_SyCampusGrpID_U_C_IDX  PrimaryKey  CampusGroupId 

CampusGroup Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
SevisCampusDetail  Non-Identifying  One To Zero or More          NO 
SchoolStartDate  Non-Identifying  One To Zero or More          NO 
ShiftSchoolStartDate  Non-Identifying  One To Zero or More          NO 
CourseAttribute  Non-Identifying  One To Zero or More          NO 
CatalogYear  Non-Identifying  One To Zero or More          NO 
AdClassSchedCancelReason  Non-Identifying  One To Zero or More          NO 
AreaOfStudy  Non-Identifying  One To Zero or More          NO 
AdCourseFulfillmentOrder  Non-Identifying  One To Zero or More          NO 
AdCoursePrefix  Non-Identifying  One To Zero or More          NO 
StudentCourseStatusChangeReason  Non-Identifying  One To Zero or More          NO 
AdFinalGradeReason  Non-Identifying  One To Zero or More          NO 
GpaCalculationType  Non-Identifying  One To Zero or More          NO 
AdLesson  Non-Identifying  One To Zero or More          NO 
AdLessonPlan  Non-Identifying  One To Zero or More          NO 
AdLocation  Non-Identifying  One To Zero or More          NO 
AdProgramTermsInAY  Non-Identifying  One To Zero or More          NO 
RegistrationGroup  Non-Identifying  One To Zero or More          NO 
TermProgramAssociation  Non-Identifying  One To Zero or More          NO 
AdTermProgramAssociation  Non-Identifying  One To Zero or More          NO 
ApplicationForm  Non-Identifying  One To Zero or More          NO 
EntranceTestLocation  Non-Identifying  One To Zero or More          NO 
CmDocMgmtSftDetail  Non-Identifying  One To Zero or More          NO 
ExcusedAbsencePolicyCode  Non-Identifying  One To Zero or More          NO 
FaTermAssociationTrack  Non-Identifying  One To Zero or More          NO 
FaTermAssociationTrackProgramVersion  Non-Identifying  One To Zero or More          NO 
FaTermTrack  Non-Identifying  One To Zero or More          NO 
HousingBuilding  Non-Identifying  One To Zero or More          NO 
HsBuildingCategories  Non-Identifying  One To Zero or More          NO 
HsHousingDates  Non-Identifying  One To Zero or More          NO 
HsRoomCategories  Non-Identifying  One To Zero or More          NO 
HsSuiteCategories  Non-Identifying  One To Zero or More          NO 
EmployerAttribute  Non-Identifying  One To Zero or More          NO 
Certification  Non-Identifying  One To Zero or More          NO 
EmployerCareerField  Non-Identifying  One To Zero or More          NO 
EmployerContactJobSkill  Non-Identifying  One To Zero or More          NO 
EmployerContactSoftSkill  Non-Identifying  One To Zero or More          NO 
EmployerSoftSkill  Non-Identifying  One To Zero or More          NO 
JobBenefit  Non-Identifying  One To Zero or More          NO 
AccountStatus  Non-Identifying  One To Zero or More          NO 
GeneralLedgerReleaseBatch  Non-Identifying  One To Zero or More          NO 
JournalEntry  Non-Identifying  One To Zero or More          NO 
SubsidiaryAccountType  Non-Identifying  One To Zero or More          NO 
TuitionDiscountPolicy  Non-Identifying  One To Zero or More          NO 
AthleticStatus  Non-Identifying  One To Zero or More          NO 
DisabilityStatus  Non-Identifying  One To Zero or More          NO 
StudentAthleteRecruitmentType  Non-Identifying  One To Zero or More          NO 
StudentServicesRoomType  Non-Identifying  One To Zero or More          NO 
ServiceType  Non-Identifying  One To Zero or More          NO 
ServiceTypeCategory  Non-Identifying  One To Zero or More          NO 
Sport  Non-Identifying  One To Zero or More          NO 
SyEmpGroups  Non-Identifying  One To Zero or More          NO 
SyEmpGrp  Non-Identifying  One To Zero or More          NO 
syIMSConfiguration  Non-Identifying  One To Zero or More          NO 
SyIndicator  Non-Identifying  One To Zero or More          NO 
SyOrganization  Non-Identifying  One To Zero or More          NO 
SyResidencyStatus  Non-Identifying  One To Zero or More          NO 
SyResidencyType  Non-Identifying  One To Zero or More          NO 
SevisCampusDetail  Non-Identifying  One To Zero or More          NO 
StaffGroupTemplateSetting  Non-Identifying  One To Zero or More          NO 

CampusGroup Check Constraints 
Check Constraint Name  CheckConstraint 

CampusGroup Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.CampusGroup 
NO       
Physical (Microsoft SQL Server)
dbo.SyCampusGrp 
NO       

CampusGroup Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  SEVIS 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 
Physical (Microsoft SQL Server)  System 

CampusGroup Data Movement Rules 
Name  Type  Rule Text/Value